/*
 Navicat Premium Data Transfer

 Source Server         : zhiyundata-aliyun-北京
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : rm-2ze83dmwmh18p67jtjo.mysql.rds.aliyuncs.com:3306
 Source Schema         : award2021_chhca

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 10/03/2021 20:36:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for workflow_phases
-- ----------------------------
DROP TABLE IF EXISTS `workflow_phases`;
CREATE TABLE `workflow_phases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phase_id` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `large_group_id` int(11) DEFAULT NULL COMMENT '0 代表该阶段与大组无关',
  `phase_name` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_begun` tinyint(4) DEFAULT NULL,
  `has_ended` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `workflow_phases_UN` (`phase_id`,`large_group_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of workflow_phases
-- ----------------------------
BEGIN;
INSERT INTO `workflow_phases` VALUES (1, 'A', 0, '申报', 1, 0);
INSERT INTO `workflow_phases` VALUES (2, 'B', 0, '形式审查', 1, 0);
INSERT INTO `workflow_phases` VALUES (3, 'C', 1, '分配评审', 1, 0);
INSERT INTO `workflow_phases` VALUES (4, 'C', 2, '分配评审', 1, 0);
INSERT INTO `workflow_phases` VALUES (5, 'C', 3, '分配评审', 1, 0);
INSERT INTO `workflow_phases` VALUES (6, 'C', 4, '分配评审', 1, 0);
INSERT INTO `workflow_phases` VALUES (7, 'C', 5, '分配评审', 0, 0);
INSERT INTO `workflow_phases` VALUES (8, 'D', 1, '专家评审', 0, 0);
INSERT INTO `workflow_phases` VALUES (9, 'D', 2, '专家评审', 0, 0);
INSERT INTO `workflow_phases` VALUES (10, 'D', 3, '专家评审', 0, 0);
INSERT INTO `workflow_phases` VALUES (11, 'D', 4, '专家评审', 0, 0);
INSERT INTO `workflow_phases` VALUES (12, 'D', 5, '专家评审', 0, 0);
INSERT INTO `workflow_phases` VALUES (13, 'E', 1, '会评', 0, 0);
INSERT INTO `workflow_phases` VALUES (14, 'E', 2, '会评', 0, 0);
INSERT INTO `workflow_phases` VALUES (15, 'E', 3, '会评', 0, 0);
INSERT INTO `workflow_phases` VALUES (16, 'E', 4, '会评', 0, 0);
INSERT INTO `workflow_phases` VALUES (17, 'E', 5, '会评', 0, 0);
INSERT INTO `workflow_phases` VALUES (18, 'F', 1, '设置授奖等级', 0, 0);
INSERT INTO `workflow_phases` VALUES (19, 'F', 2, '设置授奖等级', 0, 0);
INSERT INTO `workflow_phases` VALUES (20, 'F', 3, '设置授奖等级', 0, 0);
INSERT INTO `workflow_phases` VALUES (21, 'F', 4, '设置授奖等级', 0, 0);
INSERT INTO `workflow_phases` VALUES (22, 'F', 5, '设置授奖等级', 0, 0);
INSERT INTO `workflow_phases` VALUES (23, 'G', 1, '投票', 0, 0);
INSERT INTO `workflow_phases` VALUES (24, 'G', 2, '投票', 0, 0);
INSERT INTO `workflow_phases` VALUES (25, 'G', 3, '投票', 0, 0);
INSERT INTO `workflow_phases` VALUES (26, 'G', 4, '投票', 0, 0);
INSERT INTO `workflow_phases` VALUES (27, 'G', 5, '投票', 0, 0);
INSERT INTO `workflow_phases` VALUES (28, 'H', 1, '准备答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (29, 'H', 2, '准备答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (30, 'H', 3, '准备答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (31, 'H', 4, '准备答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (32, 'H', 5, '准备答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (33, 'I', 1, '答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (34, 'I', 2, '答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (35, 'I', 3, '答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (36, 'I', 4, '答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (37, 'I', 5, '答辩', 0, 0);
INSERT INTO `workflow_phases` VALUES (38, 'J', 1, '授奖', 0, 0);
INSERT INTO `workflow_phases` VALUES (39, 'J', 2, '授奖', 0, 0);
INSERT INTO `workflow_phases` VALUES (40, 'J', 3, '授奖', 0, 0);
INSERT INTO `workflow_phases` VALUES (41, 'J', 4, '授奖', 0, 0);
INSERT INTO `workflow_phases` VALUES (42, 'J', 5, '授奖', 0, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
